Student Solution

-->

"Education is the most powerful weapon which you can use to change the world”
– Nelson Mandela

1 University

1 Course

2 Subjects

Running Queries and Reports

Running Queries and Reports

Q Navigate to the Running Queries and Reports Tutorials using this link https://edu.gcfglobal.org/en/access/ (Links to an external site.). Review each tutorial and then write a summary. 8. Designing a Simple Query 9. Designing a Multi-table Query 10. More Query Design Options 11. Creating Reports 12. Advanced Report Options Write, in your own words, a one-two paragraph summary on the Running Queries and Reports tutorials. Apply critical thinking and an academic writing style that demonstrates your understanding of the difference between a Microsoft Access database and an Excel spreadsheet by comparing the features of each and when they would be used as personal computer applications if applicable. Scoring criteria • Information is correct and written in your own words - 75% • Academic writing style with correct spelling, grammar, punctuation - 20% • Outside sources - 5% PreviousNext

View Related Questions

Solution Preview

Through Access database you retrieve or get the data by doing a simple query by defining a detailed search and will pull out the information from the tables that have all the information stored. It will withdraw information from various tables, so you need to be specific, examples maybe by a name or address or email. You can also do multi-table queries, which will ask you more deep detailed questions to create a multi-table query, for example: Search for customers, Customers that have purchased previously, Customers who live in Boston only, by a specific Last name and on Date of Service of 11/20/2020.